-----------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/juanpablouribetrujillo/My Drive (jp.uribe86@gmail.com)/Research/MyPapers/MTU/JUE/analys
> is/../logs/universe_composition.log
  log type:  text
 opened on:  24 Jun 2024, 22:25:12

. *-------------------------****** OUTPUT SETTINGS *****---------------------;
. *settings some settings that are common for the set of plots on this dofile;
.  local pdf_plot_settings =      `"scale(*1.5) ymtick(##4) "';

. *settings for latex tables ;
. **NOTE: This table has and additional line compared to the other latex preheading
>  ( \bigskip\\[6ex])
>  \setlength{\tabcolsep}{1.2pt}
>  ;
.                 global prehead_start "prehead(\begin{table}[ht]\centering 
>                 \def\sym#1{\ifmmode^{#1}\else\(^{#1}\)\fi}  
>                 \caption{@title}
>                 \setlength{\tabcolsep}{3pt}";

.                 local font_size "";

.                                 global prehead_end         "\begin{tabular}{l*{@span}{c}}\hline\hline)";

.                 global prehead_end_bigskip "\begin{tabular}{l*{@span}{c}}\hline\hline \bigskip\\[6ex])";

.                                 global postfoot "postfoot(\hline\hline
>         \multicolumn{@span}{l}{ \footnotesize @note  }\\
>                 \multicolumn{@span}{l}{ \footnotesize  @starlegend.    }
>                 \end{tabular}   \end{table})";

.                                                                                                         l
> ocal tex_settigns  = `"
>                 ${prehead_start}
>                 `font_size'
>                 ${prehead_end}
>                 ${postfoot}
>                 "';

.         global SE_note "Standard Errors in Parentheses Clustered at the State Level";

.  *----------------------------------------------------------------------------------;
. use "../data/state_year_all_80_15.dta", clear  ;

. *---------------------------------------------------;
. * - Generate variables and general cleanings ;
. *---------------------------------------------------;
. do "_programs_universe";

. 
. # delim ;  
delimiter now ;
. ****************************************;
.         *-This program is used to add a row indicating the use of sample id when using areg;
. cap program drop add_lab_FE;

. program define add_lab_FE;
  1.         matrix V = [vecdiag(e(V)),1];
  2.         matrix V=diag(V);
  3.         matrix b=[e(b),1];
  4.         matrix colnames b= `:  colnames e(b)' `1';
  5.         matrix colnames V= `:  colnames e(V)' `1';
  6.         erepost b=b V=V ,rename;
  7. end;

. ****************************************;
.         *-This program calculates summary stats for regression tables;
. cap program drop sum_stats;

. program define sum_stats;
  1.         sum Du_lane_miles_IH ;
  2.         estadd  scalar mean_Du_lane_miles_IH =r(mean) ;
  3.         sum exp_L_IH_SF12a_r ;
  4.         estadd  scalar mean_exp_L_IH_SF12a_r=r(mean) ;
  5. end;

. ****************************************;
.         *-This program plots year dummies for slope of PPF against time;
. cap program drop plot_dummies;

. program define plot_dummies;
  1.         *settings for plots;
.         local pdf_plot_settings =       "bgcolor(white) 
>                                         graphregion(color(white)) plotregion(ls(none))  
>                                         xmtick(1984(1)2008)  
>                                         xlabel(1984(4)2008)
>                                         ymtick(##5)
>                                         scale(*1.5)  
>                                         legend(off)";
  2.         preserve;
  3.         *save se to disk;
.         mata: se=sqrt(diagonal(st_matrix("e(V)")));
  4.  // converts e(V) into se and placed in mata matrix se
>         clear;
  5.         getmata se, force ;
  6.         gen counter=_n;
  7.         save se,replace;
  8.                 *save coefficients to disk and organize;
.         mat beta=e(b);
  9.         mat list beta;
 10.         clear;
 11.         set obs 1;
 12.         display"1";
 13.         svmat double beta;
 14.         *file in memory is a single row year effects from regression;
.         gen dummy=1;
 15.         display"1";
 16.         reshape long beta,  i(dummy) j(year);
 17.         gen counter=_n;
 18.         *merge with se;
.         merge 1:1 counter using se;
 19.         drop if counter>25;
 20.         drop _merge counter;
 21.         *just keep year X expenditure coefficients;
.         drop if year==.;
 22.         replace year = year+1983;
 23.         sort year;
 24.         *file in memory gives bin, mean y and se;
.         gen up5 = beta+1.96*se;
 25.         gen down5 = beta-1.96*se;
 26.         save beta, replace;
 27.         *file in memory is a list of year by year inverse prices and CI's;
.         twoway (rcap up5 down5 year, lstyle(ci)) (scatter beta year),`pdf_plot_settings' xtitle("") ;
 28.         graph export "temp_t.pdf", replace;
 29.         erase se.dta;
 30.         erase beta.dta;
 31.         save "temp_betas.dta", replace;
 32.         restore;
 33. end;

. ****************************************;
.         *-This program plots year dummies for DL vs expenditure;
. cap program drop plot_DLdummies ;

. program define plot_DLdummies;
  1.         *settings for plots;
.         local pdf_plot_settings =       "bgcolor(white) 
>                                         graphregion(color(white)) plotregion(ls(none))  
>                                         xmtick(1980(1)2008)  
>                                         xlabel(1980(10)2010)
>                                         ymtick(##5)
>                                         scale(*1.5)  
>                                         legend(off)";
  2.         preserve;
  3.         *save se to disk;
.         mata: se=sqrt(diagonal(st_matrix("e(V)")));
  4.  // converts e(V) into se and placed in mata matrix se
>         clear;
  5.         getmata se, force ;
  6.         gen counter=_n;
  7.         save se,replace;
  8.                 *save coefficients to disk and organize;
.         mat beta=e(b);
  9.         mat list beta;
 10.         clear;
 11.         set obs 1;
 12.         svmat double beta;
 13.         *file in memory is a single row year effects from regression;
.         gen dummy=1;
 14.         reshape long beta,  i(dummy) j(exp);
 15.         gen counter=_n;
 16.         *merge with se;
.         merge 1:1 counter using se;
 17.         drop if counter>7;
 18.         drop _merge counter;
 19.                 *just keep year X expenditure coefficients;
.         drop if exp==.;
 20.         replace exp = exp*100-50;
 21.         sort exp;
 22.         *file in memory gives bin, mean y and se;
.         gen up5 = beta+1.96*se;
 23.         gen down5 = beta-1.96*se;
 24.         save beta, replace;
 25.         *file in memory is a list of year by year inverse prices and CI's;
.         twoway (rcap up5 down5 exp, lstyle(ci)) (scatter beta exp), xtitle("") `pdf_plot_settings';
 26.         graph export "temp_t.pdf", replace;
 27.         erase se.dta;
 28.         erase beta.dta;
 29.         restore;
 30. end;

. ****************************************;
. 
end of do-file

. do "_setup_expenditure.do";

. /******************************************************************
> 
> setup_expenditure.do
> 
> Subroutine to calculate expenditure variables for all analysis programs;
> 
> mt 20190506
> *******************************************************************/
. # delim ;  
delimiter now ;
. * expenditure on length and IRI from SF12a. Check that categories are right. Can we break apart ROW?;
. *conversion factor to get to 10^6 2010 dollars;
. gen deflate= 1/(ppiaco_2010*10);

. *gen deflate= 1;
. *consolidate rural and urban SF12a variables that we need;
. local rur_urb_list      "exp_eng_row_IH                 exp_row_IH              exp_eng_IH              e
> xp_new_cons_IH
>                         exp_relocation_IH               exp_recons_IH           exp_recons_add_IH       e
> xp_recons_noadd_IH
>                         exp_maj_wide_IH                 exp_R3_IH               exp_R3_min_wide_IH      e
> xp_R3_rehab_rest_IH    
>                         exp_R3_resurf_IH
>                         exp_new_bridge_IH exp_bridgereplacement_IH exp_majorbridgerehab_IH exp_minorbridg
> erehab_IH exp_bridge_IH
>                         ";

. foreach exp_var of local rur_urb_list{;
  2.                 replace `exp_var'_urban=cond(`exp_var'_urban==.,0,`exp_var'_urban);
  3.                 replace `exp_var'_rural=cond(`exp_var'_rural==.,0,`exp_var'_rural);
  4.                 gen `exp_var'_all = `exp_var'_urban + `exp_var'_rural;
  5.                 drop `exp_var'_urban `exp_var'_rural;
  6.                 };
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)
(565 real changes made)
(564 real changes made)

. *consolidate SF12a variables into nominal construction and resurfacing for pre and post 1998;
. *NB: exp_new_cons_IH_all and exp_maj_wide_IH_all are common to pre and post 1998 construction;
. gen exp_L_IH_SF12a_n_old=       exp_eng_row_IH_all + exp_new_cons_IH_all + exp_maj_wide_IH_all;

. gen exp_IRI_IH_SF12a_n_old=     exp_recons_IH_all  + exp_R3_IH_all;

.  gen exp_L_IH_SF12a_n_new=      exp_row_IH_all     + exp_eng_IH_all      + exp_new_cons_IH_all  + exp_rel
> ocation_IH_all + exp_maj_wide_IH_all;

.                         gen exp_IRI_IH_SF12a_n_new=     exp_recons_add_IH  + exp_recons_noadd_IH + exp_R3
> _min_wide_IH   + exp_R3_rehab_rest_IH  + exp_R3_resurf_IH;

. * Do the same for bridge expenditure ;
. gen exp_bridge_IH_SF12a_n_new=cond( year>1998,
>                                                                         exp_new_bridge_IH_all+exp_bridger
> eplacement_IH_all+exp_majorbridgerehab_IH_all+exp_minorbridgerehab_IH_all,.);
(931 missing values generated)

.                                                                         gen exp_bridge_IH_SF12a_n_old=con
> d( year<=1998,
>                                                                         exp_bridge_IH_all,.);
(833 missing values generated)

. *diagnostics -- should all be zero -- this test won't work for construction;
. sum exp_IRI_IH_SF12a_n_new exp_IRI_IH_SF12a_n_old if year>1998;

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
exp_IRI_IH~w |        833    75901.17    142629.8          0    1142287
exp_IRI_IH~d |        833           0           0          0          0

. sum exp_IRI_IH_SF12a_n_new exp_IRI_IH_SF12a_n_old if year<=1998;

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
exp_IRI_IH~w |        931           0           0          0          0
exp_IRI_IH~d |        931    47717.58    68779.22          0     560136

. *consolidate pre and post 1998 variable construction;
. gen exp_IRI_IH_SF12a_n =        cond(year>1998, exp_IRI_IH_SF12a_n_new, exp_IRI_IH_SF12a_n_old);

. gen exp_L_IH_SF12a_n =          cond(year>1998, exp_L_IH_SF12a_n_new, exp_L_IH_SF12a_n_old);

. gen exp_bridge_IH_SF12a_n =             cond(year>1998, exp_bridge_IH_SF12a_n_new, exp_bridge_IH_SF12a_n_
> old);

. *clean up -- save reloacation;
. gen temp = exp_relocation_IH_all;

. gen temp2 =exp_row_IH_all ;

. foreach exp_var of local rur_urb_list{;
  2.                 drop `exp_var'_all;
  3.                 };

.                 drop *_new *_old;

. rename temp exp_relocation_IH_all_n;

.  rename temp2 exp_row_IH_all_n ;

. *calculate total IH and SF12a maintenance;
. gen exp_IH_total_SF12_n = exp_IH_mtn_all + exp_IH_k_all;
(180 missing values generated)

. gen exp_IH_mtn_SF12a_n = exp_IH_total_SF12_n - exp_IRI_IH_SF12a_n - exp_L_IH_SF12a_n -exp_bridge_IH_SF12a
> _n;
(180 missing values generated)

. sum exp_IH_mtn_SF12a_n, d ;

                     exp_IH_mtn_SF12a_n
-------------------------------------------------------------
      Percentiles      Smallest
 1%       -34577        -796329
 5%            0        -387772
10%         4495        -242600       Obs               1,584
25%        13109        -198478       Sum of wgt.       1,584

50%     33878.59                      Mean           108119.7
                        Largest       Std. dev.      250930.4
75%     94553.93        2017193
90%       252167        2062267       Variance       6.30e+10
95%       424198        3278198       Skewness       5.866655
99%      1313969        3303381       Kurtosis         52.087

. replace exp_IH_mtn_SF12a_n= cond(exp_IH_mtn_SF12a_n<0,0,exp_IH_mtn_SF12a_n );
(27 real changes made)

. sum exp_IH_mtn_SF12a_n, d ;

                     exp_IH_mtn_SF12a_n
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%         4495              0       Obs               1,584
25%        13109              0       Sum of wgt.       1,584

50%     33878.59                      Mean           109822.3
                        Largest       Std. dev.      248973.5
75%     94553.93        2017193
90%       252167        2062267       Variance       6.20e+10
95%       424198        3278198       Skewness       6.026436
99%      1313969        3303381       Kurtosis       53.45254

. ;
. *convert to real 2010 USD 10^6;
. *NB: deflate calculated in calling program;
. rename app_IH app_IH_n;

. rename exp_IH_mtn_all exp_IH_mtn_SF12_n;

. ren rev_grand_total_mt rev_grand_total_mt_n;

. ren rev_total_h rev_total_h_n;

. ren rev_total_mt rev_total_mt_n ;

. ren rev_total_m_fuel_h rev_total_m_fuel_h_n ;

. local real_list "exp_IH_total_SF12 exp_IH_mtn_SF12a exp_IRI_IH_SF12a exp_L_IH_SF12a app_IH exp_IH_mtn_SF1
> 2 exp_relocation_IH_all 
>                                  rev_grand_total_mt rev_total_h rev_total_mt rev_total_m_fuel_h
>                                  exp_bridge_IH_SF12a exp_row_IH_all
>                                  ";

. foreach exp_var of local real_list{;
  2.                 gen `exp_var'_r=deflate*`exp_var'_n;
  3.                 drop `exp_var'_n;
  4.                 };
(180 missing values generated)
(180 missing values generated)
(900 missing values generated)
(180 missing values generated)
(996 missing values generated)
(228 missing values generated)
(996 missing values generated)
(228 missing values generated)

.         forvalues i=1(1)5{;
  2.                                 gen deflate_L`i'= 1/(ppiaco_2010_L`i'*10);
  3.                 ren L`i'FHWA_apport_LW L`i'FHWA_apport_LW_n;
  4.                 gen L`i'FHWA_apport_LW_r=deflate_L`i'*L`i'FHWA_apport_LW_n;
  5.                 drop L`i'FHWA_apport_LW_n;
  6. };
(132 missing values generated)
(180 missing values generated)
(228 missing values generated)
(276 missing values generated)
(324 missing values generated)

.                                                 *label and drop superflous expenditure data;
. label var       exp_IH_total_SF12_r     "Total IH exp SF12 real";

. label var       exp_IH_mtn_SF12_r       "Total IH maint exp SF12 real";

. label var       exp_IH_mtn_SF12a_r      "Total IH maint exp SF12a real";

.  label var      exp_IRI_IH_SF12a_r      "Total IH IRI exp SF12a real";

.  label var      exp_L_IH_SF12a_r        "Total IH L exp SF12a real";

. label var       app_IH_r                "Total IH approp real";

. label var       exp_relocation_IH_all   "Total IH exp relocation, >1998";

. label var   rev_grand_total_mt_r          "Total revenue mass transit account real [source: FE9 p2 ]";

. label var   rev_total_mt_r        "Total revenue highway and mass transit account real [source: FE9 p2 ]"
> ;

. label var   rev_total_h  "Total revenue highway account real [source: FE9 p2 ]";

. label var rev_total_m_fuel_h                     "Total Revenue motor fuel  (Highway motor fuel) [source:
>  FE9 p1 ]";

.         *drop exp_IH_k_rural-exp_subtotal_mtn_urban;
. exit;

end of do-file

. do "_cleaning_and_new_variables.do";

. 
. 
. 
. 
. # d ; 
delimiter now ;
. *label variables to mathc the names in the tables ;
. label var exp_L_IH_SF12a_r "\(I^{L}_{st} \)";

. label var  exp_IRI_IH_SF12a_r "\( Y^L\:in\:IRI \)";

. label var  exp_IH_mtn_SF12a_r "\( Y^L\: in\: Maint.\)";

. *make lagged expenditure and appropriations;
. sort state year;

. gen L1exp_L_IH_SF12a_r=cond(
>                         state[_n]==year[_n-1],
>                         year[_n-1]==year[_n]-1,
>                         exp_L_IH_SF12a_r[_n-1],.);
(1 missing value generated)

. gen L5app_IH_r=cond(
>                         state[_n]==year[_n-5],
>                         year[_n-5]==year[_n]-5,
>                         app_IH_r[_n-5],.);
(901 missing values generated)

.                         gen L1app_IH_r=cond(
>                         state[_n]==year[_n-1],
>                         year[_n-1]==year[_n]-1,
>                         app_IH_r[_n-1],.);
(900 missing values generated)

.                                                                         *calculate first differences in m
> iles and IRI;
. *local D_vars "u_iri_IH u_iri_urban u_iri_rural u_lane_miles_IH u_lane_miles_rural u_lane_miles_urban";
. local D_vars u_lane_miles_IH  u_lane_miles_rural u_lane_miles_urban u_miles_IH;

. sort state year;

. foreach varname of local D_vars{;
  2.                 gen D`varname'=cond(
>                                 state[_n]==state[_n-1]&
>                                 `varname'[_n-1]!=.&`varname'[_n]!=.&
>                                 `varname'[_n-1]!=0&`varname'[_n]!=0&
>                                 year[_n-1]==year[_n]-1,
>                                 `varname'[_n]-`varname'[_n-1],.);
  3.                                 };
(342 missing values generated)
(402 missing values generated)
(346 missing values generated)
(342 missing values generated)

.                                 *Create average width of lane miles ;
. gen u_width_IH= u_lane_miles_IH/u_miles_IH;
(293 missing values generated)

. label var u_width_IH "Avergae width of lanes";

.                                 *create expantion lanes in existing segments and new segments;
.                                 gen Du_expantion_miles_IH=cond(
>                                 state[_n]==state[_n-1]&
>                                 u_lane_miles_IH[_n-1]!=.&u_lane_miles_IH[_n]!=.&
>                                 u_miles_IH[_n-1]!=.&u_miles_IH[_n]!=.&
>                                 year[_n-1]==year[_n]-1,
>                                 Du_lane_miles_IH - Du_miles_IH*u_width_IH[_n-1],
>                                 .);
(342 missing values generated)

. *replace Du_expantion_miles_IH=0 if Du_expantion_miles_IH<0;
.                         label var Du_expantion_miles_IH "Expansion miles";

.                                 //note: The assumption to create this variable is that the new miles occu
> rs at mean width ;
> 
> gen sh_new_lm=cond(state[_n]==state[_n-1]&
>                                 u_lane_miles_IH[_n-1]!=.&u_lane_miles_IH[_n]!=.&
>                                 u_miles_IH[_n-1]!=.&u_miles_IH[_n]!=.&
>                                 year[_n-1]==year[_n]-1, Du_miles_IH*u_width_IH/Du_lane_miles_IH,.) ;
(494 missing values generated)

. *replace sh_new_lm=1 if Du_expantion_miles_IH==0 & Du_lane_miles_IH>0;
. label var sh_new_lm "Share of new lane miles in new segments";

. gen sh_exp_lm= Du_expantion_miles_IH/Du_lane_miles_IH;
(494 missing values generated)

. label var sh_exp_lm "Share of new lane miles that are expantions";

. *dropping missing d_lane_miles saves trouble later;
. * keep all years with lagge appropriations;
. * N.B.: Nothing strange here.  SF12a missing <1984;
. drop if year>2008|year<1980;
(343 observations deleted)

. drop if u_lane_miles_IH==.;
(0 observations deleted)

. drop if u_lane_miles_IH==0;
(0 observations deleted)

. drop if u_lane_miles_IH<0;
(0 observations deleted)

. *drop DC;
. drop if state==11;
(29 observations deleted)

. * time, for estimating trends;
. gen time =year-1984;

. gen time2 =time^2;

. gen time3 =time^3;

. label var time2 "\(time^2\)" ;

. label var time3 "\(time^3\)" ;

. *TIME TREND DUMMIES;
. gen     periods=1 if  year>=1984&year<=1989;
(1,104 missing values generated)

. replace periods=2 if  year>=1990&year<=1994;
(240 real changes made)

. replace periods=3 if  year>=1995&year<=1999;
(240 real changes made)

. replace periods=4 if  year>=2000&year<=2004;
(240 real changes made)

. replace periods=5 if  year>=2005&year<=2008;
(192 real changes made)

. tab year periods, m ;

           |                              periods
 Book year |         1          2          3          4          5          . |     Total
-----------+------------------------------------------------------------------+----------
      1980 |         0          0          0          0          0         48 |        48 
      1981 |         0          0          0          0          0         48 |        48 
      1982 |         0          0          0          0          0         48 |        48 
      1983 |         0          0          0          0          0         48 |        48 
      1984 |        48          0          0          0          0          0 |        48 
      1985 |        48          0          0          0          0          0 |        48 
      1986 |        48          0          0          0          0          0 |        48 
      1987 |        48          0          0          0          0          0 |        48 
      1988 |        48          0          0          0          0          0 |        48 
      1989 |        48          0          0          0          0          0 |        48 
      1990 |         0         48          0          0          0          0 |        48 
      1991 |         0         48          0          0          0          0 |        48 
      1992 |         0         48          0          0          0          0 |        48 
      1993 |         0         48          0          0          0          0 |        48 
      1994 |         0         48          0          0          0          0 |        48 
      1995 |         0          0         48          0          0          0 |        48 
      1996 |         0          0         48          0          0          0 |        48 
      1997 |         0          0         48          0          0          0 |        48 
      1998 |         0          0         48          0          0          0 |        48 
      1999 |         0          0         48          0          0          0 |        48 
      2000 |         0          0          0         48          0          0 |        48 
      2001 |         0          0          0         48          0          0 |        48 
      2002 |         0          0          0         48          0          0 |        48 
      2003 |         0          0          0         48          0          0 |        48 
      2004 |         0          0          0         48          0          0 |        48 
      2005 |         0          0          0          0         48          0 |        48 
      2006 |         0          0          0          0         48          0 |        48 
      2007 |         0          0          0          0         48          0 |        48 
      2008 |         0          0          0          0         48          0 |        48 
-----------+------------------------------------------------------------------+----------
     Total |       288        240        240        240        192        192 |     1,392 

. label define periods 1 "1984-1989"
>                                         2 "1990-1994"
>                                         3 "1995-1999"
>                                         4 "2000-2004"
>                                         5 "2005-2008";

. label values periods periods;

. # d cr ;
delimiter now cr
. 
. 
end of do-file

. gen u_aadt_IH=          u_vmt_IH/u_lane_miles_IH;

. gen u_aadt_10000_IH =u_aadt_IH/10000;

. *EXTRAS;
. sum  state year ppiaco_2010 deflate exp_L_IH_SF12a_r exp_IRI_IH_SF12a_r exp_L_IH_SF12a_r   exp_IH_mtn_SF1
> 2a_r exp_IH_mtn_SF12_r;

    Variable |        Obs        Mean    Std. dev.       Min        Max
-------------+---------------------------------------------------------
       state |      1,392     30.1875    15.29255          1         56
        year |      1,392        1994    8.369607       1980       2008
 ppiaco_2010 |      1,392    67.35228    12.10203   46.83892   99.50523
     deflate |      1,392    .0015299    .0002579    .001005    .002135
exp_L_IH_S~r |      1,392    116.9471    198.6732          0   2316.786
-------------+---------------------------------------------------------
exp_IRI_IH~r |      1,392    106.8798    152.0985          0   1159.081
exp_L_IH_S~r |      1,392    116.9471    198.6732          0   2316.786
exp_IH_m~a_r |      1,392    82.14829    117.4653          0   1752.363
exp_IH_m~2_r |      1,392    44.05086     58.5015          0   533.8277

. *fix too long variable name;
. rename s_average_grade_seg_constant_IH s_avg_grade_seg_con_IH;

. *drop pre-1990 hpms grade observations b/c they are too messy;
. replace s_average_grade_seg_IH =cond(year<1990,.,s_average_grade_seg_IH);
(86 real changes made, 86 to missing)

. *HPMS urban share;
. gen urban_share_IH= u_lane_miles_urban/u_lane_miles_IH;

. drop if year<1984;
(192 observations deleted)

. tab year;

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1984 |         48        4.00        4.00
       1985 |         48        4.00        8.00
       1986 |         48        4.00       12.00
       1987 |         48        4.00       16.00
       1988 |         48        4.00       20.00
       1989 |         48        4.00       24.00
       1990 |         48        4.00       28.00
       1991 |         48        4.00       32.00
       1992 |         48        4.00       36.00
       1993 |         48        4.00       40.00
       1994 |         48        4.00       44.00
       1995 |         48        4.00       48.00
       1996 |         48        4.00       52.00
       1997 |         48        4.00       56.00
       1998 |         48        4.00       60.00
       1999 |         48        4.00       64.00
       2000 |         48        4.00       68.00
       2001 |         48        4.00       72.00
       2002 |         48        4.00       76.00
       2003 |         48        4.00       80.00
       2004 |         48        4.00       84.00
       2005 |         48        4.00       88.00
       2006 |         48        4.00       92.00
       2007 |         48        4.00       96.00
       2008 |         48        4.00      100.00
------------+-----------------------------------
      Total |      1,200      100.00

. drop if exp_L_IH_SF12a_r==.;
(0 observations deleted)

. drop if exp_L_IH_SF12a_r==0;
(29 observations deleted)

. drop if exp_L_IH_SF12a_r<0;
(0 observations deleted)

. tab year;

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1984 |         44        3.76        3.76
       1985 |         46        3.93        7.69
       1986 |         47        4.01       11.70
       1987 |         45        3.84       15.54
       1988 |         44        3.76       19.30
       1989 |         47        4.01       23.31
       1990 |         45        3.84       27.16
       1991 |         45        3.84       31.00
       1992 |         47        4.01       35.01
       1993 |         45        3.84       38.86
       1994 |         46        3.93       42.78
       1995 |         46        3.93       46.71
       1996 |         48        4.10       50.81
       1997 |         48        4.10       54.91
       1998 |         48        4.10       59.01
       1999 |         48        4.10       63.11
       2000 |         48        4.10       67.21
       2001 |         48        4.10       71.31
       2002 |         48        4.10       75.41
       2003 |         48        4.10       79.50
       2004 |         48        4.10       83.60
       2005 |         48        4.10       87.70
       2006 |         48        4.10       91.80
       2007 |         48        4.10       95.90
       2008 |         48        4.10      100.00
------------+-----------------------------------
      Total |      1,171      100.00

. replace s_average_grade_seg_IH=. if year<1992;
(87 real changes made, 87 to missing)

. tab year;

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1984 |         44        3.76        3.76
       1985 |         46        3.93        7.69
       1986 |         47        4.01       11.70
       1987 |         45        3.84       15.54
       1988 |         44        3.76       19.30
       1989 |         47        4.01       23.31
       1990 |         45        3.84       27.16
       1991 |         45        3.84       31.00
       1992 |         47        4.01       35.01
       1993 |         45        3.84       38.86
       1994 |         46        3.93       42.78
       1995 |         46        3.93       46.71
       1996 |         48        4.10       50.81
       1997 |         48        4.10       54.91
       1998 |         48        4.10       59.01
       1999 |         48        4.10       63.11
       2000 |         48        4.10       67.21
       2001 |         48        4.10       71.31
       2002 |         48        4.10       75.41
       2003 |         48        4.10       79.50
       2004 |         48        4.10       83.60
       2005 |         48        4.10       87.70
       2006 |         48        4.10       91.80
       2007 |         48        4.10       95.90
       2008 |         48        4.10      100.00
------------+-----------------------------------
      Total |      1,171      100.00

. *------------------------------------------------;
. * loop through composition variables regressions ;
. *------------------------------------------------;
. label var time "t";

.         local listcontinous "c.time cont Baseline" ;

. local listcontinous2 "c.time_+_c.time2 cont_2 " ;

. local listdiscrete  "ib2.periods dum Periods" ;

. local keep_rule "if 1==1 ";

. replace sh_new_lm =. if year==1984;
(42 real changes made, 42 to missing)

.         eststo clear ;

. *make second table with all variables;
. *baseline, for reference;
. *eststo ,prefix(filter_): reg Du_lane_miles_IH exp_L_IH_SF12a_r,  cluster(state);
. *eststo ,prefix(filter_): reg Du_lane_miles_IH exp_L_IH_SF12a_r c.exp_L_IH_SF12a_r#c.time  time,  cluster
> (state);
. *composition variable: hpms grade;
. local i=1;

. foreach pair in    "s_average_grade_seg_IH      HPMS_grade HPMS-Grade"
>                                         "sh_elev_10m_s                   elev       Elevation"
>                                         "sh_h20_10m_s                    nlcd_h2o   NLCD-Water"
>                                         "sh_urb_10m_s                    nlcd_urb   NLCD-Urban"
>                                         "urban_share_IH                  hpms_urb   HPMS-Urban"
>                                         "unionization_Mem_Total                  union      Unionization 
> "
>                                         "u_aadt_10000_IH             aadt       AADT"
>                                         "sh_new_lm                   sh_new     New-miles "
>                                         "s_sn_d_IH                                              sn       
>        Structural-x-Number"
>                                         "s_share_rig_st_IH                      rigid_share  Share-x-rigi
> d "    
>                         {;
  2.                         local comp_var = word("`pair'",1);
  3.                         local var_title = word("`pair'",2);
  4.                         local col_title = word("`pair'",3);
  5.                         gen comp_temp = `comp_var';
  6.                         label var comp_temp "\(x\)";
  7.                                                 eststo ,prefix(filter_): reghdfe Du_lane_miles_IH exp_
> L_IH_SF12a_r c.exp_L_IH_SF12a_r#(c.time) c.time
>                                                                 c.comp_temp c.comp_temp#c.exp_L_IH_SF12a_
> r c.comp_temp#c.exp_L_IH_SF12a_r#(c.time),  
>                                                                 abs(state) cluster(state);
  8.                         drop comp_temp;
  9.                                                 * To add titles to the columns ;
.                         local tit`i' "`col_title'";
 10.                         local i=`i'+1;
 11.                                                 di "`comp_var'";
 12.                         tab year if e(sample)==1;
 13.                         tab state if e(sample)==1;
 14.                         pause ;
 15.                                                 };
(372 missing values generated)
(MWFE estimator converged in 1 iterations)

HDFE Linear regression                            Number of obs   =        799
Absorbing 1 HDFE group                            F(   6,     47) =       7.05
Statistics robust to heteroskedasticity           Prob > F        =     0.0000
                                                  R-squared       =     0.1683
                                                  Adj R-squared   =     0.1092
                                                  Within R-sq.    =     0.0163
Number of clusters (state)   =         48         Root MSE        =    49.6687

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |   .1674139   .1075164     1.56   0.126    -.0488812    .3837089
                                      |
            c.exp_L_IH_SF12a_r#c.time |  -.0056367   .0041873    -1.35   0.185    -.0140604     .002787
                                      |
                                 time |   .0413123   .2890633     0.14   0.887    -.5402081    .6228328
                            comp_temp |   2.469887   6.975781     0.35   0.725    -11.56357    16.50335
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |  -.0597246   .0566655    -1.05   0.297    -.1737207    .0542716
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |    -.00032   .0033728    -0.09   0.925    -.0071051    .0064651
                                      |
                                _cons |   13.70945   10.51298     1.30   0.199     -7.43994    34.85884
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_1 stored)
s_average_grade_seg_IH

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1992 |         47        5.88        5.88
       1993 |         45        5.63       11.51
       1994 |         45        5.63       17.15
       1995 |         46        5.76       22.90
       1996 |         46        5.76       28.66
       1997 |         48        6.01       34.67
       1998 |         47        5.88       40.55
       1999 |         47        5.88       46.43
       2000 |         47        5.88       52.32
       2001 |         47        5.88       58.20
       2002 |         47        5.88       64.08
       2003 |         47        5.88       69.96
       2004 |         48        6.01       75.97
       2005 |         48        6.01       81.98
       2006 |         48        6.01       87.98
       2007 |         48        6.01       93.99
       2008 |         48        6.01      100.00
------------+-----------------------------------
      Total |        799      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         17        2.13        2.13
             ARIZONA |         16        2.00        4.13
            ARKANSAS |         17        2.13        6.26
          CALIFORNIA |         17        2.13        8.39
            COLORADO |         17        2.13       10.51
         CONNECTICUT |         17        2.13       12.64
            DELAWARE |         17        2.13       14.77
             FLORIDA |         17        2.13       16.90
             GEORGIA |         17        2.13       19.02
               IDAHO |         17        2.13       21.15
            ILLINOIS |         17        2.13       23.28
             INDIANA |         17        2.13       25.41
                IOWA |         17        2.13       27.53
              KANSAS |         15        1.88       29.41
            KENTUCKY |         16        2.00       31.41
           LOUISIANA |         15        1.88       33.29
               MAINE |         17        2.13       35.42
            MARYLAND |         17        2.13       37.55
       MASSACHUSETTS |         11        1.38       38.92
            MICHIGAN |         17        2.13       41.05
           MINNESOTA |         16        2.00       43.05
         MISSISSIPPI |         17        2.13       45.18
            MISSOURI |         17        2.13       47.31
             MONTANA |         17        2.13       49.44
            NEBRASKA |         17        2.13       51.56
              NEVADA |         14        1.75       53.32
       NEW HAMPSHIRE |         17        2.13       55.44
          NEW JERSEY |         17        2.13       57.57
          NEW MEXICO |         17        2.13       59.70
            NEW YORK |         17        2.13       61.83
      NORTH CAROLINA |         17        2.13       63.95
        NORTH DAKOTA |         17        2.13       66.08
                OHIO |         17        2.13       68.21
            OKLAHOMA |         17        2.13       70.34
              OREGON |         17        2.13       72.47
        PENNSYLVANIA |         17        2.13       74.59
        RHODE ISLAND |         17        2.13       76.72
      SOUTH CAROLINA |         17        2.13       78.85
        SOUTH DAKOTA |         17        2.13       80.98
           TENNESSEE |         17        2.13       83.10
               TEXAS |         17        2.13       85.23
                UTAH |         17        2.13       87.36
             VERMONT |         17        2.13       89.49
            VIRGINIA |         16        2.00       91.49
          WASHINGTON |         17        2.13       93.62
       WEST VIRGINIA |         17        2.13       95.74
           WISCONSIN |         17        2.13       97.87
             WYOMING |         17        2.13      100.00
---------------------+-----------------------------------
               Total |        799      100.00
note: comp_temp is probably collinear with the fixed effects (all partialled-out values are close to zero; 
> tol = 1.0e-09)
(MWFE estimator converged in 1 iterations)
note: comp_temp omitted because of collinearity

HDFE Linear regression                            Number of obs   =      1,171
Absorbing 1 HDFE group                            F(   5,     47) =       5.92
Statistics robust to heteroskedasticity           Prob > F        =     0.0003
                                                  R-squared       =     0.1865
                                                  Adj R-squared   =     0.1486
                                                  Within R-sq.    =     0.0347
Number of clusters (state)   =         48         Root MSE        =    53.3833

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |   .0490653   .0322996     1.52   0.135    -.0159132    .1140438
                                      |
            c.exp_L_IH_SF12a_r#c.time |  -.0034379   .0016606    -2.07   0.044    -.0067786   -.0000972
                                      |
                                 time |  -.6017692    .283617    -2.12   0.039    -1.172333   -.0312055
                            comp_temp |          0  (omitted)
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |   .0000646   .0000941     0.69   0.496    -.0001247    .0002538
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |  -2.87e-06   4.73e-06    -0.61   0.546    -.0000124    6.64e-06
                                      |
                                _cons |   28.08895   4.338456     6.47   0.000      19.3611     36.8168
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_2 stored)
sh_elev_10m_s

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1984 |         44        3.76        3.76
       1985 |         46        3.93        7.69
       1986 |         47        4.01       11.70
       1987 |         45        3.84       15.54
       1988 |         44        3.76       19.30
       1989 |         47        4.01       23.31
       1990 |         45        3.84       27.16
       1991 |         45        3.84       31.00
       1992 |         47        4.01       35.01
       1993 |         45        3.84       38.86
       1994 |         46        3.93       42.78
       1995 |         46        3.93       46.71
       1996 |         48        4.10       50.81
       1997 |         48        4.10       54.91
       1998 |         48        4.10       59.01
       1999 |         48        4.10       63.11
       2000 |         48        4.10       67.21
       2001 |         48        4.10       71.31
       2002 |         48        4.10       75.41
       2003 |         48        4.10       79.50
       2004 |         48        4.10       83.60
       2005 |         48        4.10       87.70
       2006 |         48        4.10       91.80
       2007 |         48        4.10       95.90
       2008 |         48        4.10      100.00
------------+-----------------------------------
      Total |      1,171      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         25        2.13        2.13
             ARIZONA |         24        2.05        4.18
            ARKANSAS |         25        2.13        6.32
          CALIFORNIA |         24        2.05        8.37
            COLORADO |         25        2.13       10.50
         CONNECTICUT |         25        2.13       12.64
            DELAWARE |         23        1.96       14.60
             FLORIDA |         25        2.13       16.74
             GEORGIA |         25        2.13       18.87
               IDAHO |         25        2.13       21.01
            ILLINOIS |         25        2.13       23.14
             INDIANA |         25        2.13       25.28
                IOWA |         25        2.13       27.41
              KANSAS |         23        1.96       29.38
            KENTUCKY |         23        1.96       31.34
           LOUISIANA |         21        1.79       33.13
               MAINE |         25        2.13       35.27
            MARYLAND |         22        1.88       37.15
       MASSACHUSETTS |         23        1.96       39.11
            MICHIGAN |         24        2.05       41.16
           MINNESOTA |         23        1.96       43.13
         MISSISSIPPI |         24        2.05       45.18
            MISSOURI |         25        2.13       47.31
             MONTANA |         25        2.13       49.44
            NEBRASKA |         25        2.13       51.58
              NEVADA |         22        1.88       53.46
       NEW HAMPSHIRE |         25        2.13       55.59
          NEW JERSEY |         25        2.13       57.73
          NEW MEXICO |         25        2.13       59.86
            NEW YORK |         25        2.13       62.00
      NORTH CAROLINA |         25        2.13       64.13
        NORTH DAKOTA |         25        2.13       66.27
                OHIO |         25        2.13       68.40
            OKLAHOMA |         25        2.13       70.54
              OREGON |         25        2.13       72.67
        PENNSYLVANIA |         25        2.13       74.81
        RHODE ISLAND |         21        1.79       76.60
      SOUTH CAROLINA |         25        2.13       78.74
        SOUTH DAKOTA |         25        2.13       80.87
           TENNESSEE |         25        2.13       83.01
               TEXAS |         25        2.13       85.14
                UTAH |         25        2.13       87.28
             VERMONT |         24        2.05       89.33
            VIRGINIA |         25        2.13       91.46
          WASHINGTON |         25        2.13       93.60
       WEST VIRGINIA |         25        2.13       95.73
           WISCONSIN |         25        2.13       97.87
             WYOMING |         25        2.13      100.00
---------------------+-----------------------------------
               Total |      1,171      100.00
note: comp_temp is probably collinear with the fixed effects (all partialled-out values are close to zero; 
> tol = 1.0e-09)
(MWFE estimator converged in 1 iterations)
note: comp_temp omitted because of collinearity

HDFE Linear regression                            Number of obs   =      1,171
Absorbing 1 HDFE group                            F(   5,     47) =       6.22
Statistics robust to heteroskedasticity           Prob > F        =     0.0002
                                                  R-squared       =     0.1872
                                                  Adj R-squared   =     0.1494
                                                  Within R-sq.    =     0.0356
Number of clusters (state)   =         48         Root MSE        =    53.3586

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |   .0244894   .0456156     0.54   0.594    -.0672774    .1162563
                                      |
            c.exp_L_IH_SF12a_r#c.time |  -.0027484   .0017055    -1.61   0.114    -.0061794    .0006826
                                      |
                                 time |  -.6896965   .2717588    -2.54   0.015    -1.236405   -.1429883
                            comp_temp |          0  (omitted)
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |   .3040541   .3001778     1.01   0.316    -.2998258    .9079339
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |  -.0103372   .0107031    -0.97   0.339     -.031869    .0111946
                                      |
                                _cons |   30.31014   4.284831     7.07   0.000     21.69017    38.93011
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_3 stored)
sh_h20_10m_s

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1984 |         44        3.76        3.76
       1985 |         46        3.93        7.69
       1986 |         47        4.01       11.70
       1987 |         45        3.84       15.54
       1988 |         44        3.76       19.30
       1989 |         47        4.01       23.31
       1990 |         45        3.84       27.16
       1991 |         45        3.84       31.00
       1992 |         47        4.01       35.01
       1993 |         45        3.84       38.86
       1994 |         46        3.93       42.78
       1995 |         46        3.93       46.71
       1996 |         48        4.10       50.81
       1997 |         48        4.10       54.91
       1998 |         48        4.10       59.01
       1999 |         48        4.10       63.11
       2000 |         48        4.10       67.21
       2001 |         48        4.10       71.31
       2002 |         48        4.10       75.41
       2003 |         48        4.10       79.50
       2004 |         48        4.10       83.60
       2005 |         48        4.10       87.70
       2006 |         48        4.10       91.80
       2007 |         48        4.10       95.90
       2008 |         48        4.10      100.00
------------+-----------------------------------
      Total |      1,171      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         25        2.13        2.13
             ARIZONA |         24        2.05        4.18
            ARKANSAS |         25        2.13        6.32
          CALIFORNIA |         24        2.05        8.37
            COLORADO |         25        2.13       10.50
         CONNECTICUT |         25        2.13       12.64
            DELAWARE |         23        1.96       14.60
             FLORIDA |         25        2.13       16.74
             GEORGIA |         25        2.13       18.87
               IDAHO |         25        2.13       21.01
            ILLINOIS |         25        2.13       23.14
             INDIANA |         25        2.13       25.28
                IOWA |         25        2.13       27.41
              KANSAS |         23        1.96       29.38
            KENTUCKY |         23        1.96       31.34
           LOUISIANA |         21        1.79       33.13
               MAINE |         25        2.13       35.27
            MARYLAND |         22        1.88       37.15
       MASSACHUSETTS |         23        1.96       39.11
            MICHIGAN |         24        2.05       41.16
           MINNESOTA |         23        1.96       43.13
         MISSISSIPPI |         24        2.05       45.18
            MISSOURI |         25        2.13       47.31
             MONTANA |         25        2.13       49.44
            NEBRASKA |         25        2.13       51.58
              NEVADA |         22        1.88       53.46
       NEW HAMPSHIRE |         25        2.13       55.59
          NEW JERSEY |         25        2.13       57.73
          NEW MEXICO |         25        2.13       59.86
            NEW YORK |         25        2.13       62.00
      NORTH CAROLINA |         25        2.13       64.13
        NORTH DAKOTA |         25        2.13       66.27
                OHIO |         25        2.13       68.40
            OKLAHOMA |         25        2.13       70.54
              OREGON |         25        2.13       72.67
        PENNSYLVANIA |         25        2.13       74.81
        RHODE ISLAND |         21        1.79       76.60
      SOUTH CAROLINA |         25        2.13       78.74
        SOUTH DAKOTA |         25        2.13       80.87
           TENNESSEE |         25        2.13       83.01
               TEXAS |         25        2.13       85.14
                UTAH |         25        2.13       87.28
             VERMONT |         24        2.05       89.33
            VIRGINIA |         25        2.13       91.46
          WASHINGTON |         25        2.13       93.60
       WEST VIRGINIA |         25        2.13       95.73
           WISCONSIN |         25        2.13       97.87
             WYOMING |         25        2.13      100.00
---------------------+-----------------------------------
               Total |      1,171      100.00
note: comp_temp is probably collinear with the fixed effects (all partialled-out values are close to zero; 
> tol = 1.0e-09)
(MWFE estimator converged in 1 iterations)
note: comp_temp omitted because of collinearity

HDFE Linear regression                            Number of obs   =      1,171
Absorbing 1 HDFE group                            F(   5,     47) =       7.04
Statistics robust to heteroskedasticity           Prob > F        =     0.0001
                                                  R-squared       =     0.1881
                                                  Adj R-squared   =     0.1503
                                                  Within R-sq.    =     0.0366
Number of clusters (state)   =         48         Root MSE        =    53.3318

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |   .1561185   .0918384     1.70   0.096    -.0286365    .3408734
                                      |
            c.exp_L_IH_SF12a_r#c.time |  -.0095375   .0036071    -2.64   0.011    -.0167941   -.0022809
                                      |
                                 time |  -.5246405   .2663771    -1.97   0.055    -1.060522     .011241
                            comp_temp |          0  (omitted)
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |  -.4831555    .370797    -1.30   0.199    -1.229103    .2627918
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |   .0290686   .0161489     1.80   0.078    -.0034188     .061556
                                      |
                                _cons |   26.86397   5.032743     5.34   0.000      16.7394    36.98854
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_4 stored)
sh_urb_10m_s

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1984 |         44        3.76        3.76
       1985 |         46        3.93        7.69
       1986 |         47        4.01       11.70
       1987 |         45        3.84       15.54
       1988 |         44        3.76       19.30
       1989 |         47        4.01       23.31
       1990 |         45        3.84       27.16
       1991 |         45        3.84       31.00
       1992 |         47        4.01       35.01
       1993 |         45        3.84       38.86
       1994 |         46        3.93       42.78
       1995 |         46        3.93       46.71
       1996 |         48        4.10       50.81
       1997 |         48        4.10       54.91
       1998 |         48        4.10       59.01
       1999 |         48        4.10       63.11
       2000 |         48        4.10       67.21
       2001 |         48        4.10       71.31
       2002 |         48        4.10       75.41
       2003 |         48        4.10       79.50
       2004 |         48        4.10       83.60
       2005 |         48        4.10       87.70
       2006 |         48        4.10       91.80
       2007 |         48        4.10       95.90
       2008 |         48        4.10      100.00
------------+-----------------------------------
      Total |      1,171      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         25        2.13        2.13
             ARIZONA |         24        2.05        4.18
            ARKANSAS |         25        2.13        6.32
          CALIFORNIA |         24        2.05        8.37
            COLORADO |         25        2.13       10.50
         CONNECTICUT |         25        2.13       12.64
            DELAWARE |         23        1.96       14.60
             FLORIDA |         25        2.13       16.74
             GEORGIA |         25        2.13       18.87
               IDAHO |         25        2.13       21.01
            ILLINOIS |         25        2.13       23.14
             INDIANA |         25        2.13       25.28
                IOWA |         25        2.13       27.41
              KANSAS |         23        1.96       29.38
            KENTUCKY |         23        1.96       31.34
           LOUISIANA |         21        1.79       33.13
               MAINE |         25        2.13       35.27
            MARYLAND |         22        1.88       37.15
       MASSACHUSETTS |         23        1.96       39.11
            MICHIGAN |         24        2.05       41.16
           MINNESOTA |         23        1.96       43.13
         MISSISSIPPI |         24        2.05       45.18
            MISSOURI |         25        2.13       47.31
             MONTANA |         25        2.13       49.44
            NEBRASKA |         25        2.13       51.58
              NEVADA |         22        1.88       53.46
       NEW HAMPSHIRE |         25        2.13       55.59
          NEW JERSEY |         25        2.13       57.73
          NEW MEXICO |         25        2.13       59.86
            NEW YORK |         25        2.13       62.00
      NORTH CAROLINA |         25        2.13       64.13
        NORTH DAKOTA |         25        2.13       66.27
                OHIO |         25        2.13       68.40
            OKLAHOMA |         25        2.13       70.54
              OREGON |         25        2.13       72.67
        PENNSYLVANIA |         25        2.13       74.81
        RHODE ISLAND |         21        1.79       76.60
      SOUTH CAROLINA |         25        2.13       78.74
        SOUTH DAKOTA |         25        2.13       80.87
           TENNESSEE |         25        2.13       83.01
               TEXAS |         25        2.13       85.14
                UTAH |         25        2.13       87.28
             VERMONT |         24        2.05       89.33
            VIRGINIA |         25        2.13       91.46
          WASHINGTON |         25        2.13       93.60
       WEST VIRGINIA |         25        2.13       95.73
           WISCONSIN |         25        2.13       97.87
             WYOMING |         25        2.13      100.00
---------------------+-----------------------------------
               Total |      1,171      100.00
(MWFE estimator converged in 1 iterations)

HDFE Linear regression                            Number of obs   =      1,171
Absorbing 1 HDFE group                            F(   6,     47) =       9.48
Statistics robust to heteroskedasticity           Prob > F        =     0.0000
                                                  R-squared       =     0.1931
                                                  Adj R-squared   =     0.1548
                                                  Within R-sq.    =     0.0426
Number of clusters (state)   =         48         Root MSE        =    53.1904

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |    .200651    .089484     2.24   0.030     .0206325    .3806695
                                      |
            c.exp_L_IH_SF12a_r#c.time |  -.0132882   .0038638    -3.44   0.001    -.0210612   -.0055153
                                      |
                                 time |  -.2756319   .3371248    -0.82   0.418    -.9538395    .4025757
                            comp_temp |  -44.41034   49.63578    -0.89   0.375    -144.2646    55.44396
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |  -.2889658   .1377033    -2.10   0.041    -.5659891   -.0119424
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |    .019406   .0066176     2.93   0.005     .0060931    .0327189
                                      |
                                _cons |   38.52902   14.98448     2.57   0.013     8.384131     68.6739
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_5 stored)
urban_share_IH

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1984 |         44        3.76        3.76
       1985 |         46        3.93        7.69
       1986 |         47        4.01       11.70
       1987 |         45        3.84       15.54
       1988 |         44        3.76       19.30
       1989 |         47        4.01       23.31
       1990 |         45        3.84       27.16
       1991 |         45        3.84       31.00
       1992 |         47        4.01       35.01
       1993 |         45        3.84       38.86
       1994 |         46        3.93       42.78
       1995 |         46        3.93       46.71
       1996 |         48        4.10       50.81
       1997 |         48        4.10       54.91
       1998 |         48        4.10       59.01
       1999 |         48        4.10       63.11
       2000 |         48        4.10       67.21
       2001 |         48        4.10       71.31
       2002 |         48        4.10       75.41
       2003 |         48        4.10       79.50
       2004 |         48        4.10       83.60
       2005 |         48        4.10       87.70
       2006 |         48        4.10       91.80
       2007 |         48        4.10       95.90
       2008 |         48        4.10      100.00
------------+-----------------------------------
      Total |      1,171      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         25        2.13        2.13
             ARIZONA |         24        2.05        4.18
            ARKANSAS |         25        2.13        6.32
          CALIFORNIA |         24        2.05        8.37
            COLORADO |         25        2.13       10.50
         CONNECTICUT |         25        2.13       12.64
            DELAWARE |         23        1.96       14.60
             FLORIDA |         25        2.13       16.74
             GEORGIA |         25        2.13       18.87
               IDAHO |         25        2.13       21.01
            ILLINOIS |         25        2.13       23.14
             INDIANA |         25        2.13       25.28
                IOWA |         25        2.13       27.41
              KANSAS |         23        1.96       29.38
            KENTUCKY |         23        1.96       31.34
           LOUISIANA |         21        1.79       33.13
               MAINE |         25        2.13       35.27
            MARYLAND |         22        1.88       37.15
       MASSACHUSETTS |         23        1.96       39.11
            MICHIGAN |         24        2.05       41.16
           MINNESOTA |         23        1.96       43.13
         MISSISSIPPI |         24        2.05       45.18
            MISSOURI |         25        2.13       47.31
             MONTANA |         25        2.13       49.44
            NEBRASKA |         25        2.13       51.58
              NEVADA |         22        1.88       53.46
       NEW HAMPSHIRE |         25        2.13       55.59
          NEW JERSEY |         25        2.13       57.73
          NEW MEXICO |         25        2.13       59.86
            NEW YORK |         25        2.13       62.00
      NORTH CAROLINA |         25        2.13       64.13
        NORTH DAKOTA |         25        2.13       66.27
                OHIO |         25        2.13       68.40
            OKLAHOMA |         25        2.13       70.54
              OREGON |         25        2.13       72.67
        PENNSYLVANIA |         25        2.13       74.81
        RHODE ISLAND |         21        1.79       76.60
      SOUTH CAROLINA |         25        2.13       78.74
        SOUTH DAKOTA |         25        2.13       80.87
           TENNESSEE |         25        2.13       83.01
               TEXAS |         25        2.13       85.14
                UTAH |         25        2.13       87.28
             VERMONT |         24        2.05       89.33
            VIRGINIA |         25        2.13       91.46
          WASHINGTON |         25        2.13       93.60
       WEST VIRGINIA |         25        2.13       95.73
           WISCONSIN |         25        2.13       97.87
             WYOMING |         25        2.13      100.00
---------------------+-----------------------------------
               Total |      1,171      100.00
(MWFE estimator converged in 1 iterations)

HDFE Linear regression                            Number of obs   =      1,171
Absorbing 1 HDFE group                            F(   6,     47) =       9.56
Statistics robust to heteroskedasticity           Prob > F        =     0.0000
                                                  R-squared       =     0.1895
                                                  Adj R-squared   =     0.1510
                                                  Within R-sq.    =     0.0383
Number of clusters (state)   =         48         Root MSE        =    53.3079

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |   .1214812   .0738828     1.64   0.107    -.0271518    .2701141
                                      |
            c.exp_L_IH_SF12a_r#c.time |  -.0092795   .0030726    -3.02   0.004    -.0154607   -.0030983
                                      |
                                 time |  -.5597064   .3339209    -1.68   0.100    -1.231469    .1120559
                            comp_temp |   .2789465   1.325615     0.21   0.834    -2.387847     2.94574
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |  -.0040403   .0042991    -0.94   0.352     -.012689    .0046085
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |   .0003657   .0002039     1.79   0.079    -.0000445    .0007759
                                      |
                                _cons |   24.88775   20.80436     1.20   0.238    -16.96523    66.74073
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_6 stored)
unionization_Mem_Total

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1984 |         44        3.76        3.76
       1985 |         46        3.93        7.69
       1986 |         47        4.01       11.70
       1987 |         45        3.84       15.54
       1988 |         44        3.76       19.30
       1989 |         47        4.01       23.31
       1990 |         45        3.84       27.16
       1991 |         45        3.84       31.00
       1992 |         47        4.01       35.01
       1993 |         45        3.84       38.86
       1994 |         46        3.93       42.78
       1995 |         46        3.93       46.71
       1996 |         48        4.10       50.81
       1997 |         48        4.10       54.91
       1998 |         48        4.10       59.01
       1999 |         48        4.10       63.11
       2000 |         48        4.10       67.21
       2001 |         48        4.10       71.31
       2002 |         48        4.10       75.41
       2003 |         48        4.10       79.50
       2004 |         48        4.10       83.60
       2005 |         48        4.10       87.70
       2006 |         48        4.10       91.80
       2007 |         48        4.10       95.90
       2008 |         48        4.10      100.00
------------+-----------------------------------
      Total |      1,171      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         25        2.13        2.13
             ARIZONA |         24        2.05        4.18
            ARKANSAS |         25        2.13        6.32
          CALIFORNIA |         24        2.05        8.37
            COLORADO |         25        2.13       10.50
         CONNECTICUT |         25        2.13       12.64
            DELAWARE |         23        1.96       14.60
             FLORIDA |         25        2.13       16.74
             GEORGIA |         25        2.13       18.87
               IDAHO |         25        2.13       21.01
            ILLINOIS |         25        2.13       23.14
             INDIANA |         25        2.13       25.28
                IOWA |         25        2.13       27.41
              KANSAS |         23        1.96       29.38
            KENTUCKY |         23        1.96       31.34
           LOUISIANA |         21        1.79       33.13
               MAINE |         25        2.13       35.27
            MARYLAND |         22        1.88       37.15
       MASSACHUSETTS |         23        1.96       39.11
            MICHIGAN |         24        2.05       41.16
           MINNESOTA |         23        1.96       43.13
         MISSISSIPPI |         24        2.05       45.18
            MISSOURI |         25        2.13       47.31
             MONTANA |         25        2.13       49.44
            NEBRASKA |         25        2.13       51.58
              NEVADA |         22        1.88       53.46
       NEW HAMPSHIRE |         25        2.13       55.59
          NEW JERSEY |         25        2.13       57.73
          NEW MEXICO |         25        2.13       59.86
            NEW YORK |         25        2.13       62.00
      NORTH CAROLINA |         25        2.13       64.13
        NORTH DAKOTA |         25        2.13       66.27
                OHIO |         25        2.13       68.40
            OKLAHOMA |         25        2.13       70.54
              OREGON |         25        2.13       72.67
        PENNSYLVANIA |         25        2.13       74.81
        RHODE ISLAND |         21        1.79       76.60
      SOUTH CAROLINA |         25        2.13       78.74
        SOUTH DAKOTA |         25        2.13       80.87
           TENNESSEE |         25        2.13       83.01
               TEXAS |         25        2.13       85.14
                UTAH |         25        2.13       87.28
             VERMONT |         24        2.05       89.33
            VIRGINIA |         25        2.13       91.46
          WASHINGTON |         25        2.13       93.60
       WEST VIRGINIA |         25        2.13       95.73
           WISCONSIN |         25        2.13       97.87
             WYOMING |         25        2.13      100.00
---------------------+-----------------------------------
               Total |      1,171      100.00
(MWFE estimator converged in 1 iterations)

HDFE Linear regression                            Number of obs   =      1,171
Absorbing 1 HDFE group                            F(   6,     47) =       5.89
Statistics robust to heteroskedasticity           Prob > F        =     0.0001
                                                  R-squared       =     0.1941
                                                  Adj R-squared   =     0.1558
                                                  Within R-sq.    =     0.0437
Number of clusters (state)   =         48         Root MSE        =    53.1580

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |   .2067801   .1049602     1.97   0.055    -.0043726    .4179328
                                      |
            c.exp_L_IH_SF12a_r#c.time |  -.0120153   .0051705    -2.32   0.025     -.022417   -.0016136
                                      |
                                 time |   .3712889   .4295192     0.86   0.392    -.4927923     1.23537
                            comp_temp |  -.1384095   .0809043    -1.71   0.094     -.301168     .024349
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |  -.0004459   .0002504    -1.78   0.081    -.0009495    .0000578
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |   .0000254    .000013     1.96   0.056    -7.07e-07    .0000514
                                      |
                                _cons |   51.93871   18.49796     2.81   0.007     14.72561    89.15181
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_7 stored)
u_aadt_10000_IH

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1984 |         44        3.76        3.76
       1985 |         46        3.93        7.69
       1986 |         47        4.01       11.70
       1987 |         45        3.84       15.54
       1988 |         44        3.76       19.30
       1989 |         47        4.01       23.31
       1990 |         45        3.84       27.16
       1991 |         45        3.84       31.00
       1992 |         47        4.01       35.01
       1993 |         45        3.84       38.86
       1994 |         46        3.93       42.78
       1995 |         46        3.93       46.71
       1996 |         48        4.10       50.81
       1997 |         48        4.10       54.91
       1998 |         48        4.10       59.01
       1999 |         48        4.10       63.11
       2000 |         48        4.10       67.21
       2001 |         48        4.10       71.31
       2002 |         48        4.10       75.41
       2003 |         48        4.10       79.50
       2004 |         48        4.10       83.60
       2005 |         48        4.10       87.70
       2006 |         48        4.10       91.80
       2007 |         48        4.10       95.90
       2008 |         48        4.10      100.00
------------+-----------------------------------
      Total |      1,171      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         25        2.13        2.13
             ARIZONA |         24        2.05        4.18
            ARKANSAS |         25        2.13        6.32
          CALIFORNIA |         24        2.05        8.37
            COLORADO |         25        2.13       10.50
         CONNECTICUT |         25        2.13       12.64
            DELAWARE |         23        1.96       14.60
             FLORIDA |         25        2.13       16.74
             GEORGIA |         25        2.13       18.87
               IDAHO |         25        2.13       21.01
            ILLINOIS |         25        2.13       23.14
             INDIANA |         25        2.13       25.28
                IOWA |         25        2.13       27.41
              KANSAS |         23        1.96       29.38
            KENTUCKY |         23        1.96       31.34
           LOUISIANA |         21        1.79       33.13
               MAINE |         25        2.13       35.27
            MARYLAND |         22        1.88       37.15
       MASSACHUSETTS |         23        1.96       39.11
            MICHIGAN |         24        2.05       41.16
           MINNESOTA |         23        1.96       43.13
         MISSISSIPPI |         24        2.05       45.18
            MISSOURI |         25        2.13       47.31
             MONTANA |         25        2.13       49.44
            NEBRASKA |         25        2.13       51.58
              NEVADA |         22        1.88       53.46
       NEW HAMPSHIRE |         25        2.13       55.59
          NEW JERSEY |         25        2.13       57.73
          NEW MEXICO |         25        2.13       59.86
            NEW YORK |         25        2.13       62.00
      NORTH CAROLINA |         25        2.13       64.13
        NORTH DAKOTA |         25        2.13       66.27
                OHIO |         25        2.13       68.40
            OKLAHOMA |         25        2.13       70.54
              OREGON |         25        2.13       72.67
        PENNSYLVANIA |         25        2.13       74.81
        RHODE ISLAND |         21        1.79       76.60
      SOUTH CAROLINA |         25        2.13       78.74
        SOUTH DAKOTA |         25        2.13       80.87
           TENNESSEE |         25        2.13       83.01
               TEXAS |         25        2.13       85.14
                UTAH |         25        2.13       87.28
             VERMONT |         24        2.05       89.33
            VIRGINIA |         25        2.13       91.46
          WASHINGTON |         25        2.13       93.60
       WEST VIRGINIA |         25        2.13       95.73
           WISCONSIN |         25        2.13       97.87
             WYOMING |         25        2.13      100.00
---------------------+-----------------------------------
               Total |      1,171      100.00
(165 missing values generated)
(MWFE estimator converged in 1 iterations)

HDFE Linear regression                            Number of obs   =      1,006
Absorbing 1 HDFE group                            F(   6,     47) =       4.32
Statistics robust to heteroskedasticity           Prob > F        =     0.0015
                                                  R-squared       =     0.1699
                                                  Adj R-squared   =     0.1237
                                                  Within R-sq.    =     0.0341
Number of clusters (state)   =         48         Root MSE        =    56.6620

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |   .0472473   .0223163     2.12   0.040     .0023527    .0921419
                                      |
            c.exp_L_IH_SF12a_r#c.time |  -.0033084    .001049    -3.15   0.003    -.0054187   -.0011981
                                      |
                                 time |   -.729253   .3125583    -2.33   0.024    -1.358039   -.1004669
                            comp_temp |   -.272262   .2675522    -1.02   0.314    -.8105077    .2659836
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |   .0168646   .0168884     1.00   0.323    -.0171104    .0508397
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |  -.0003931   .0008026    -0.49   0.627    -.0020078    .0012216
                                      |
                                _cons |   32.74285   4.699969     6.97   0.000     23.28773    42.19797
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_8 stored)
sh_new_lm

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1985 |         45        4.47        4.47
       1986 |         45        4.47        8.95
       1987 |         41        4.08       13.02
       1988 |         41        4.08       17.10
       1989 |         44        4.37       21.47
       1990 |         43        4.27       25.75
       1991 |         41        4.08       29.82
       1992 |         44        4.37       34.19
       1993 |         42        4.17       38.37
       1994 |         42        4.17       42.54
       1995 |         42        4.17       46.72
       1996 |         41        4.08       50.80
       1997 |         41        4.08       54.87
       1998 |         43        4.27       59.15
       1999 |         40        3.98       63.12
       2000 |         42        4.17       67.30
       2001 |         39        3.88       71.17
       2002 |         43        4.27       75.45
       2003 |         40        3.98       79.42
       2004 |         42        4.17       83.60
       2005 |         43        4.27       87.87
       2006 |         41        4.08       91.95
       2007 |         40        3.98       95.92
       2008 |         41        4.08      100.00
------------+-----------------------------------
      Total |      1,006      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         22        2.19        2.19
             ARIZONA |         23        2.29        4.47
            ARKANSAS |         24        2.39        6.86
          CALIFORNIA |         24        2.39        9.24
            COLORADO |         24        2.39       11.63
         CONNECTICUT |         24        2.39       14.02
            DELAWARE |         12        1.19       15.21
             FLORIDA |         24        2.39       17.59
             GEORGIA |         24        2.39       19.98
               IDAHO |         17        1.69       21.67
            ILLINOIS |         24        2.39       24.06
             INDIANA |         15        1.49       25.55
                IOWA |         24        2.39       27.93
              KANSAS |         21        2.09       30.02
            KENTUCKY |         22        2.19       32.21
           LOUISIANA |         17        1.69       33.90
               MAINE |         20        1.99       35.88
            MARYLAND |         22        2.19       38.07
       MASSACHUSETTS |         17        1.69       39.76
            MICHIGAN |         23        2.29       42.05
           MINNESOTA |         22        2.19       44.23
         MISSISSIPPI |         22        2.19       46.42
            MISSOURI |         24        2.39       48.81
             MONTANA |         16        1.59       50.40
            NEBRASKA |         24        2.39       52.78
              NEVADA |         18        1.79       54.57
       NEW HAMPSHIRE |         20        1.99       56.56
          NEW JERSEY |         24        2.39       58.95
          NEW MEXICO |         19        1.89       60.83
            NEW YORK |         22        2.19       63.02
      NORTH CAROLINA |         24        2.39       65.41
        NORTH DAKOTA |         10        0.99       66.40
                OHIO |         24        2.39       68.79
            OKLAHOMA |         23        2.29       71.07
              OREGON |         22        2.19       73.26
        PENNSYLVANIA |         24        2.39       75.65
        RHODE ISLAND |         14        1.39       77.04
      SOUTH CAROLINA |         24        2.39       79.42
        SOUTH DAKOTA |         20        1.99       81.41
           TENNESSEE |         24        2.39       83.80
               TEXAS |         24        2.39       86.18
                UTAH |         24        2.39       88.57
             VERMONT |          4        0.40       88.97
            VIRGINIA |         24        2.39       91.35
          WASHINGTON |         23        2.29       93.64
       WEST VIRGINIA |         20        1.99       95.63
           WISCONSIN |         24        2.39       98.01
             WYOMING |         20        1.99      100.00
---------------------+-----------------------------------
               Total |      1,006      100.00
(183 missing values generated)
(MWFE estimator converged in 1 iterations)

HDFE Linear regression                            Number of obs   =        988
Absorbing 1 HDFE group                            F(   6,     47) =       4.51
Statistics robust to heteroskedasticity           Prob > F        =     0.0011
                                                  R-squared       =     0.1791
                                                  Adj R-squared   =     0.1325
                                                  Within R-sq.    =     0.0265
Number of clusters (state)   =         48         Root MSE        =    51.0114

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |  -.1195344   .1669594    -0.72   0.478    -.4554135    .2163447
                                      |
            c.exp_L_IH_SF12a_r#c.time |   .0108203   .0074048     1.46   0.151    -.0040763    .0257169
                                      |
                                 time |   -.366522   .3099391    -1.18   0.243    -.9900391    .2569951
                            comp_temp |   2.177318   3.403445     0.64   0.525    -4.669529    9.024165
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |   .0278763   .0268156     1.04   0.304    -.0260697    .0818223
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |  -.0022918   .0011597    -1.98   0.054    -.0046247    .0000411
                                      |
                                _cons |   9.751228   20.03502     0.49   0.629    -30.55403    50.05649
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_9 stored)
s_sn_d_IH

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1988 |         44        4.45        4.45
       1989 |         47        4.76        9.21
       1990 |         45        4.55       13.77
       1991 |         45        4.55       18.32
       1992 |         47        4.76       23.08
       1993 |         45        4.55       27.63
       1994 |         46        4.66       32.29
       1995 |         46        4.66       36.94
       1996 |         48        4.86       41.80
       1997 |         48        4.86       46.66
       1998 |         47        4.76       51.42
       1999 |         48        4.86       56.28
       2000 |         48        4.86       61.13
       2001 |         48        4.86       65.99
       2002 |         48        4.86       70.85
       2003 |         48        4.86       75.71
       2004 |         48        4.86       80.57
       2005 |         48        4.86       85.43
       2006 |         48        4.86       90.28
       2007 |         48        4.86       95.14
       2008 |         48        4.86      100.00
------------+-----------------------------------
      Total |        988      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         21        2.13        2.13
             ARIZONA |         20        2.02        4.15
            ARKANSAS |         21        2.13        6.28
          CALIFORNIA |         21        2.13        8.40
            COLORADO |         21        2.13       10.53
         CONNECTICUT |         21        2.13       12.65
            DELAWARE |         20        2.02       14.68
             FLORIDA |         21        2.13       16.80
             GEORGIA |         21        2.13       18.93
               IDAHO |         21        2.13       21.05
            ILLINOIS |         21        2.13       23.18
             INDIANA |         21        2.13       25.30
                IOWA |         21        2.13       27.43
              KANSAS |         19        1.92       29.35
            KENTUCKY |         19        1.92       31.28
           LOUISIANA |         20        2.02       33.30
               MAINE |         21        2.13       35.43
            MARYLAND |         21        2.13       37.55
       MASSACHUSETTS |         19        1.92       39.47
            MICHIGAN |         21        2.13       41.60
           MINNESOTA |         19        1.92       43.52
         MISSISSIPPI |         20        2.02       45.55
            MISSOURI |         21        2.13       47.67
             MONTANA |         21        2.13       49.80
            NEBRASKA |         21        2.13       51.92
              NEVADA |         18        1.82       53.74
       NEW HAMPSHIRE |         21        2.13       55.87
          NEW JERSEY |         21        2.13       58.00
          NEW MEXICO |         21        2.13       60.12
            NEW YORK |         21        2.13       62.25
      NORTH CAROLINA |         21        2.13       64.37
        NORTH DAKOTA |         21        2.13       66.50
                OHIO |         21        2.13       68.62
            OKLAHOMA |         21        2.13       70.75
              OREGON |         21        2.13       72.87
        PENNSYLVANIA |         21        2.13       75.00
        RHODE ISLAND |         18        1.82       76.82
      SOUTH CAROLINA |         21        2.13       78.95
        SOUTH DAKOTA |         21        2.13       81.07
           TENNESSEE |         21        2.13       83.20
               TEXAS |         21        2.13       85.32
                UTAH |         21        2.13       87.45
             VERMONT |         20        2.02       89.47
            VIRGINIA |         20        2.02       91.50
          WASHINGTON |         21        2.13       93.62
       WEST VIRGINIA |         21        2.13       95.75
           WISCONSIN |         21        2.13       97.87
             WYOMING |         21        2.13      100.00
---------------------+-----------------------------------
               Total |        988      100.00
(183 missing values generated)
(MWFE estimator converged in 1 iterations)

HDFE Linear regression                            Number of obs   =        988
Absorbing 1 HDFE group                            F(   6,     47) =       6.87
Statistics robust to heteroskedasticity           Prob > F        =     0.0000
                                                  R-squared       =     0.1799
                                                  Adj R-squared   =     0.1334
                                                  Within R-sq.    =     0.0275
Number of clusters (state)   =         48         Root MSE        =    50.9848

                                                          (Std. err. adjusted for 48 clusters in state)
-------------------------------------------------------------------------------------------------------
                                      |               Robust
                     Du_lane_miles_IH | Coefficient  std. err.      t    P>|t|     [95% conf. interval]
--------------------------------------+----------------------------------------------------------------
                     exp_L_IH_SF12a_r |   .0089125   .0282625     0.32   0.754    -.0479444    .0657694
                                      |
            c.exp_L_IH_SF12a_r#c.time |  -.0003083   .0015158    -0.20   0.840    -.0033577    .0027411
                                      |
                                 time |  -.1677657    .264813    -0.63   0.529    -.7005007    .3649692
                            comp_temp |   31.37335   23.32318     1.35   0.185    -15.54685    78.29354
                                      |
       c.comp_temp#c.exp_L_IH_SF12a_r |   .1645638   .1177068     1.40   0.169    -.0722316    .4013593
                                      |
c.comp_temp#c.exp_L_IH_SF12a_r#c.time |   -.011399    .005825    -1.96   0.056    -.0231173    .0003193
                                      |
                                _cons |   10.25017   8.433849     1.22   0.230    -6.716547    27.21688
-------------------------------------------------------------------------------------------------------

Absorbed degrees of freedom:
-----------------------------------------------------+
 Absorbed FE | Categories  - Redundant  = Num. Coefs |
-------------+---------------------------------------|
       state |        48          48           0    *|
-----------------------------------------------------+
* = FE nested within cluster; treated as redundant for DoF computation
(filter_10 stored)
s_share_rig_st_IH

  Book year |      Freq.     Percent        Cum.
------------+-----------------------------------
       1988 |         44        4.45        4.45
       1989 |         47        4.76        9.21
       1990 |         45        4.55       13.77
       1991 |         45        4.55       18.32
       1992 |         47        4.76       23.08
       1993 |         45        4.55       27.63
       1994 |         46        4.66       32.29
       1995 |         46        4.66       36.94
       1996 |         48        4.86       41.80
       1997 |         48        4.86       46.66
       1998 |         47        4.76       51.42
       1999 |         48        4.86       56.28
       2000 |         48        4.86       61.13
       2001 |         48        4.86       65.99
       2002 |         48        4.86       70.85
       2003 |         48        4.86       75.71
       2004 |         48        4.86       80.57
       2005 |         48        4.86       85.43
       2006 |         48        4.86       90.28
       2007 |         48        4.86       95.14
       2008 |         48        4.86      100.00
------------+-----------------------------------
      Total |        988      100.00

     State fips code |      Freq.     Percent        Cum.
---------------------+-----------------------------------
             ALABAMA |         21        2.13        2.13
             ARIZONA |         20        2.02        4.15
            ARKANSAS |         21        2.13        6.28
          CALIFORNIA |         21        2.13        8.40
            COLORADO |         21        2.13       10.53
         CONNECTICUT |         21        2.13       12.65
            DELAWARE |         20        2.02       14.68
             FLORIDA |         21        2.13       16.80
             GEORGIA |         21        2.13       18.93
               IDAHO |         21        2.13       21.05
            ILLINOIS |         21        2.13       23.18
             INDIANA |         21        2.13       25.30
                IOWA |         21        2.13       27.43
              KANSAS |         19        1.92       29.35
            KENTUCKY |         19        1.92       31.28
           LOUISIANA |         20        2.02       33.30
               MAINE |         21        2.13       35.43
            MARYLAND |         21        2.13       37.55
       MASSACHUSETTS |         19        1.92       39.47
            MICHIGAN |         21        2.13       41.60
           MINNESOTA |         19        1.92       43.52
         MISSISSIPPI |         20        2.02       45.55
            MISSOURI |         21        2.13       47.67
             MONTANA |         21        2.13       49.80
            NEBRASKA |         21        2.13       51.92
              NEVADA |         18        1.82       53.74
       NEW HAMPSHIRE |         21        2.13       55.87
          NEW JERSEY |         21        2.13       58.00
          NEW MEXICO |         21        2.13       60.12
            NEW YORK |         21        2.13       62.25
      NORTH CAROLINA |         21        2.13       64.37
        NORTH DAKOTA |         21        2.13       66.50
                OHIO |         21        2.13       68.62
            OKLAHOMA |         21        2.13       70.75
              OREGON |         21        2.13       72.87
        PENNSYLVANIA |         21        2.13       75.00
        RHODE ISLAND |         18        1.82       76.82
      SOUTH CAROLINA |         21        2.13       78.95
        SOUTH DAKOTA |         21        2.13       81.07
           TENNESSEE |         21        2.13       83.20
               TEXAS |         21        2.13       85.32
                UTAH |         21        2.13       87.45
             VERMONT |         20        2.02       89.47
            VIRGINIA |         20        2.02       91.50
          WASHINGTON |         21        2.13       93.62
       WEST VIRGINIA |         21        2.13       95.75
           WISCONSIN |         21        2.13       97.87
             WYOMING |         21        2.13      100.00
---------------------+-----------------------------------
               Total |        988      100.00

. estfe . filter_*, labels( state "State FE");

. return list;

macros:
        r(indicate_fe) : " "State FE=0.state" "

.                         esttab filter_* using "${output}/tables/TableB3_universe_comp.tex", replace
>         b(%8.3fc) se(%8.3fc)  sfmt(%8.2fc)
>         title("Composition Effects in Construction Costs\label{tab:composition_L}")
>         indicate(   `r(indicate_fe)')
>         order(   )
>         note(${SE_note})
>         star(+ 0.10 * 0.05 ** 0.01 *** 0.001)
>          unstack mtitle(
>                                         "\LongHead{15ex}{`tit1'}"
>                                         "\LongHead{15ex}{`tit2'}"
>                                         "\LongHead{15ex}{`tit3'}"
>                                         "\LongHead{15ex}{`tit4'}"
>                                         "\LongHead{15ex}{`tit5'}"
>                                         "\LongHead{15ex}{`tit6'}"
>                                         "\LongHead{15ex}{`tit7'}"
>                                         "\LongHead{15ex}{`tit8'}"
>                                         "\LongHead{15ex}{`tit9'}"
>                                         "\LongHead{15ex}{`tit10'}"
>                         )
>         noomitted   nobaselevels nonumbers
>         substitute(\_ _ 
>         "c.comp_temp" "\(x^0\)" 
>         "comp_temp" "\(x^0\)" 
>         "-x-" " "
>         "\( Y^L \) $\times$ t" 
>         "\( Y^L  t \)"
>         "\(x\) $\times$ \( Y^L \)"
>         " \( Y^L \) \(x\) "
>         "\(x\) $\times$ \( Y^L  t \)" 
>         "\(Y^L  tx\)"
>         "State FE" "\cline{2-11}State FE")
>         se  par  r2 label nogaps  drop(_cons)  compress
>         obslast stats(N, fmt(%9.0fc))
>                         ${prehead_start}
>                         ${prehead_end_bigskip}
>                         ${postfoot};
(output written to ..//tables/TableB3_universe_comp.tex)

.         ;
.   eststo clear ;

.         log close;
      name:  <unnamed>
       log:  /Users/juanpablouribetrujillo/My Drive (jp.uribe86@gmail.com)/Research/MyPapers/MTU/JUE/analys
> is/../logs/universe_composition.log
  log type:  text
 closed on:  24 Jun 2024, 22:25:23
-----------------------------------------------------------------------------------------------------------
